Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Department, Object Name, Title, Culture, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7590 | 7590 | 1984.272 | 0 | 0 | 8087 | American Decorative Arts 1 | Table 477 | Table | American 1 | Designer|Retailer 51 | Designed by|Possibly retailed by | Gustav Stickley|Tobey Furniture Company | American, Osceola, Wisconsin 1858–1942 Syracuse, New York|1875–1954 | Stickley, Gustav|Tobey Furniture Company 1059 | American|American 5 | 1858 |1875 | 1942 |1954 | 1900 | 1900 | 1900 | Oak 32 | 23 1/8 x 23 3/4 x 23 3/4 in. (58.7 x 60.3 x 60.3 cm) | Friends of the American Wing Fund, 1984 | Made in 1 | Syracuse 116 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/8087 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
66756 | 66756 | 1996.488.4a–d | 0 | 0 | 79335 | Costume Institute 8 | Boots 5898 | Boots | American 1 | Designer|Retailer 51 | Serendipity 3|The Chelsea Cobbler | American, opened 1954 | Serendipity 3|Chelsea Cobbler The 5383 | American 1 | 1954 | mid-1960s | 1963 | 1967 | leather, metal 15127 | Gift of Stephen Bruce, 1996 | http://www.metmuseum.org/art/collection/search/79335 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
66757 | 66757 | 1996.488.5a–d | 0 | 0 | 79336 | Costume Institute 8 | Boots 5898 | Boots | American 1 | Designer|Retailer 51 | Serendipity 3|The Chelsea Cobbler | American, opened 1954 | Serendipity 3|Chelsea Cobbler The 5383 | American 1 | 1954 | mid-1960s | 1963 | 1967 | leather, metal 15127 | Gift of Stephen Bruce, 1996 | http://www.metmuseum.org/art/collection/search/79336 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
67241 | 67241 | 1995.209.24 | 0 | 0 | 79873 | Costume Institute 8 | Jacket 4399 | Jacket | British 6 | Designer|Retailer 51 | Ossie Clark|Quorum | British, Oswaldtwistle 1942–1996 London | Clark, Ossie|Quorum 5491 | British 7 | 1942 | 1996 | ca. 1966 | 1961 | 1971 | suede 15107 | Gift of Mary Ann Crenshaw, 1995 | http://www.metmuseum.org/art/collection/search/79873 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
67242 | 67242 | 1995.209.25 | 0 | 0 | 79874 | Costume Institute 8 | Jacket 4399 | Jacket | British 6 | Designer|Retailer 51 | Ossie Clark|Quorum | British, Oswaldtwistle 1942–1996 London | Clark, Ossie|Quorum 5491 | British 7 | 1942 | 1996 | ca. 1966 | 1961 | 1971 | leather 15128 | Gift of Mary Ann Crenshaw, 1995 | http://www.metmuseum.org/art/collection/search/79874 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
67243 | 67243 | 1995.209.26 | 0 | 0 | 79875 | Costume Institute 8 | Jacket 4399 | Jacket | British 6 | Designer|Retailer 51 | Ossie Clark|Quorum | British, Oswaldtwistle 1942–1996 London | Clark, Ossie|Quorum 5491 | British 7 | 1942 | 1996 | ca. 1966 | 1961 | 1971 | leather 15128 | Gift of Mary Ann Crenshaw, 1995 | http://www.metmuseum.org/art/collection/search/79875 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
68831 | 68831 | C.I.58.34.15 | 0 | 0 | 81691 | Costume Institute 8 | Cocktail Dress 5933 | Cocktail dress | French 7 | Designer|Retailer 51 | Madeleine Vionnet|Hattie Carnegie, Inc. | French, Chilleurs-aux-Bois 1876–1975 Paris|American, 1918–1965 | Vionnet, Madeleine|Carnegie, Inc., Hattie 5712 | French|American 153 | 1876 |1918 | 1975 |1965 | 1936 | 1936 | 1936 | silk, metal 15118 | Gift of Mrs. John Chambers Hughes, 1958 | http://www.metmuseum.org/art/collection/search/81691 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
69581 | 69581 | 1972.27.1 | 0 | 0 | 83173 | Costume Institute 8 | Coat 4973 | Coat | American 1 | Designer|Retailer 51 | Michael Mott|Paraphernalia | American, founded 1965 | Mott Michael|Paraphernalia 5798 | 1965 | 1990 | 1966 | 1966 | 1966 | wool 15104 | Gift of Mrs. Robert A.M. Stern, 1972 | http://www.metmuseum.org/art/collection/search/83173 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
69752 | 69752 | 2001.787a, b | 0 | 0 | 83368 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | ca. 1968 | 1963 | 1973 | (a, b) silk 15900 | Gift of Judith H. Wolff, 2001 | http://www.metmuseum.org/art/collection/search/83368 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
70748 | 70748 | C.I.58.34.23a, b | 0 | 0 | 84788 | Costume Institute 8 | Evening dress 5874 | Evening dress | French 7 | Designer|Retailer 51 | Maggy Rouff|Hattie Carnegie, Inc. | French, 1896–1971|American, 1918–1965 | Rouff Maggy|Carnegie, Inc., Hattie 5964 | French|American 153 | 1896 |1918 | 1971 |1965 | 1939 | 1939 | 1939 | silk, linen 15099 | Gift of Mrs. John Chambers Hughes, 1958 | http://www.metmuseum.org/art/collection/search/84788 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74405 | 74405 | 1972.27.4 | 0 | 0 | 94772 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | for | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | 1966 | 1966 | 1966 | [no medium available] 15100 | Gift of Mrs. Robert A. M. Stern, 1972 | http://www.metmuseum.org/art/collection/search/94772 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
74407 | 74407 | 1974.384.17 | 0 | 0 | 94774 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | ca. 1968 | 1963 | 1973 | synthetic 15169 | Gift of Jane Holzer, 1974 | http://www.metmuseum.org/art/collection/search/94774 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74408 | 74408 | 1974.384.52 | 0 | 0 | 94775 | Costume Institute 8 | Dress 5877 | Dress | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | 1967–69 | 1967 | 1969 | synthetics 15103 | Gift of Jane Holzer, 1974 | http://www.metmuseum.org/art/collection/search/94775 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
74412 | 74412 | 1974.384.18a–c | 0 | 0 | 94779 | Costume Institute 8 | Kit 6282 | Kit | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | for | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | ca. 1968 | 1963 | 1973 | metal foil 16977 | Gift of Jane Holzer, 1974 | http://www.metmuseum.org/art/collection/search/94779 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
74413 | 74413 | 1974.384.37a–d | 0 | 0 | 94780 | Costume Institute 8 | Ensemble 5875 | Ensemble | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | 1967–69 | 1967 | 1969 | cotton 3340 | Gift of Jane Holzer, 1974 | http://www.metmuseum.org/art/collection/search/94780 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
75952 | 75952 | 1978.385.1 | 0 | 0 | 97573 | Costume Institute 8 | Evening dress 5874 | Evening dress | American 1 | Designer|Retailer 51 | Norman Norell|Evelyn Byrnes | American, Noblesville, Indiana 1900–1972 New York|American, founded 1956 | Norell, Norman|Byrnes, Evelyn 6358 | American|American 5 | 1900 |1956 | 1972 |2056 | 1963 | 1963 | 1963 | silk, glass, plastic 15293 | Gift of Josephine E. Glassheim in memory of parents Nathan and Mary Glassheim, 1978 | http://www.metmuseum.org/art/collection/search/97573 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
76666 | 76666 | 1974.384.25 | 0 | 0 | 98993 | Costume Institute 8 | Skirt 1152 | Skirt | American 1 | Designer|Retailer 51 | Betsey Johnson|Paraphernalia | American, born Wethersfield, Connecticut, 1942|American, founded 1965 | Johnson, Betsey|Paraphernalia 5823 | American 1 | 1942 |1965 | 2042 |1990 | 1966 | 1966 | 1966 | leather, brass 15151 | Gift of Jane Holzer, 1974 | http://www.metmuseum.org/art/collection/search/98993 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
76684 | 76684 | 1977.115.23 | 0 | 0 | 99025 | Costume Institute 8 | Jacket 4399 | Jacket | probably American 40 | Designer|Retailer 51 | Attributed to | Kenzo Takada|Jungle Jap | Japanese, born 1939 | Kenzo Takada|Jungle Jap 6396 | Japanese 74 | 1939 | 2039 | 1970–72 | 1970 | 1972 | cotton, fur 16919 | Gift of Jane Holzer, 1977 | http://www.metmuseum.org/art/collection/search/99025 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
76920 | 76920 | 42.128.1a, b | 0 | 0 | 100304 | Costume Institute 8 | Evening dress 5874 | Evening dress | American 1 | Designer|Retailer 51 | Wilson Folmar|Jay-Thorpe, Inc. | Folmar Wilson|Jay Thorpe 6417 | 1942 | 1942 | 1942 | silk 15101 | Gift of Jay Thorpe, Inc., 1942 | http://www.metmuseum.org/art/collection/search/100304 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
76923 | 76923 | 42.128.4 | 0 | 0 | 100307 | Costume Institute 8 | Evening dress 5874 | Evening dress | American 1 | Designer|Retailer 51 | Wilson Folmar|Jay-Thorpe, Inc. | Folmar Wilson|Jay Thorpe 6417 | 1942 | 1942 | 1942 | silk 15101 | Gift of Jay Thorpe, Inc., 1942 | http://www.metmuseum.org/art/collection/search/100307 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
95395 | 95395 | 2009.300.5878a–d | 0 | 0 | 170083 | Costume Institute 8 | Shoes 5896 | Shoes | French 7 | Designer|Retailer 51 | René Mancini|Daniela Shoes | French, founded 1936 | Mancini René|Daniela Shoes 7654 | French 2 | 1936 | 9999 | ca. 1963 | 1961 | 1965 | Leather 732 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1977 | http://www.metmuseum.org/art/collection/search/170083 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
95435 | 95435 | 2009.300.5927a, b | 0 | 0 | 170123 | Costume Institute 8 | Hat 1056 | Hat | American 1 | Designer|Retailer 51 | Walter Florell|The Robbins | Florell Walter|Robbins The 7661 | ca. 1945 | 1943 | 1947 | Straw, synthetic 19877 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Dorothy Haase, 1983 | http://www.metmuseum.org/art/collection/search/170123 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
95691 | 95691 | 2009.300.6125 | 0 | 0 | 170379 | Costume Institute 8 | Fedora 6411 | Fedora | American 1 | Designer|Retailer 51 | Cavanagh|Worth & Worth, Ltd. | American, founded 1928|American, founded 1922 | Cavanagh|Worth & Worth, Ltd. 7708 | American 1 | 1928 |1922 | 2028 |9999 | ca. 1950 | 1948 | 1952 | Wool, silk 16397 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009 | http://www.metmuseum.org/art/collection/search/170379 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97016 | 97016 | 2009.300.7274 | 0 | 0 | 174395 | Costume Institute 8 | Cocktail dress 6005 | Cocktail dress | American 1 | Designer|Retailer 51 | Gilbert Adrian|Bonwit Teller & Co. | American, Naugatuck, Connecticut 1903–1959 Hollywood, California|American, founded 1907 | Adrian, Gilbert|Bonwit Teller & Co. 5797 | American|American 5 | 1903 |1907 | 1959 |2050 | ca. 1944 | 1942 | 1946 | Synthetic 19874 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. V. D. Crisp, 1963 | http://www.metmuseum.org/art/collection/search/174395 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97285 | 97285 | 2009.300.7611 | 0 | 0 | 174664 | Costume Institute 8 | Jacket 4399 | Jacket | American 1 | Designer|Retailer 51 | Valentina|Chez Sonia | American, born Russia, 1899–1989 | Valentina|Chez Sonia 7853 | American 1 | 1899 | 1989 | ca. 1925 | 1923 | 1927 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the estate of Margaret Rudkin, 1967 | http://www.metmuseum.org/art/collection/search/174664 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97355 | 97355 | 2009.300.7695 | 0 | 0 | 174734 | Costume Institute 8 | Evening dress 5874 | Evening dress | American 1 | Designer|Retailer 51 | Attributed to | Fira Benenson|Bonwit Teller & Co. | American, born Baku, Russia 1898–1977 New York|American, founded 1907 | Benenson Fira|Bonwit Teller & Co. 7861 | American|American 5 | 1898 |1907 | 1977 |2050 | ca. 1943 | 1941 | 1945 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lady Emilia Dreher Armstrong, 1969 | http://www.metmuseum.org/art/collection/search/174734 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
97483 | 97483 | 2009.300.7831 | 0 | 0 | 174862 | Costume Institute 8 | Cocktail dress 6005 | Cocktail dress | American 1 | Designer|Retailer 51 | Mary Graham|Put-On | Graham Mary|Put-On 7877 | 1968 | 1968 | 1968 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Richard Palmer, 1972 | http://www.metmuseum.org/art/collection/search/174862 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
97618 | 97618 | 2009.300.7974 | 0 | 0 | 174998 | Costume Institute 8 | Sweater 5882 | Sweater | Italian 36 | Designer|Retailer 51 | Sonia Rykiel|Henri Bendel | French, Neuilly 1930–2016 Paris|American, founded 1895 | Rykiel Sonia|Bendel, Henri 6513 | French 2 | 1930 |1895 | 2016 |9999 | ca. 1977 | 1975 | 1979 | Wool, rabbit hair 20362 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Ethel Scull, 1979 | http://www.metmuseum.org/art/collection/search/174998 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97858 | 97858 | 2009.300.8221a, b | 0 | 0 | 175239 | Costume Institute 8 | Evening ensemble 5879 | Evening ensemble | French 7 | Designer|Retailer 51 | Sonia Rykiel|Henri Bendel | French, Neuilly 1930–2016 Paris|American, founded 1895 | Rykiel Sonia|Bendel, Henri 6513 | French 2 | 1930 |1895 | 2016 |9999 | ca. 1985 | 1983 | 1987 | Synthetic, silk 19864 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lauren Bacall, 1986 | http://www.metmuseum.org/art/collection/search/175239 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97969 | 97969 | 2009.300.8339 | 0 | 0 | 175350 | Costume Institute 8 | Trousers 5475 | Trousers | French 7 | Designer|Retailer 51 | Pierre Cardin|Bonwit Teller & Co. | French, born San Biagio di Callalta, Italy, 1922|American, founded 1907 | Cardin, Pierre|Bonwit Teller & Co. 6114 | French, born Italy|American 212 | 1922-07-02|1907 | 2022 |2050 | ca. 1970 | 1968 | 1972 | Wool 2116 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Stewart Johnson, 1989 | http://www.metmuseum.org/art/collection/search/175350 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
97997 | 97997 | 2009.300.8367 | 0 | 0 | 175378 | Costume Institute 8 | Shirt 5887 | Shirt | British 6 | Designer|Retailer 51 | Richard Torry|Susanne Bartsch | British, born 1960|American | Torry Richard|Bartsch, Susanne 7938 | British|American 33 | 1960 | 2060 | ca. 1985 | 1983 | 1987 | Silk 165 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mark Isaacson, 1992 | http://www.metmuseum.org/art/collection/search/175378 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");